Release 10.1A: OpenEdge Data Management:
SQL Development

Privilege basics

There are two types of privileges—those granted on databases and those granted on tables, views, and procedures.

Privileges for databases are:

Granting or restricting system administration privileges (DBA).
Granting audit privileges (audit administration, audit archive, or audit application insert).
Granting or restricting general creation privileges on a database (RESOURCE).

Privileges granted on tables, views, and procedures grant or restrict operations on specific operations, such as:

Altering an object definition.
Deleting, inserting, selecting and updating records.
Executing stored procedures.
Granting privileges.
Defining constraints to an existing table.